Demanda vs temperatura real Sonora

Dataset statistics

Number of variables	15
Number of observations	138791
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	15.9 MiB
Average record size in memory	120.0 B

Variable types

DateTime	2
Numeric	12
Categorical	1

Alerts

`Demanda` is highly correlated with `Month` and 7 other fields	High correlation
`TMAX-CAB` is highly correlated with `Demanda` and 7 other fields	High correlation
`TMAX-HMO` is highly correlated with `Demanda` and 7 other fields	High correlation
`TMAX-OBR` is highly correlated with `Demanda` and 7 other fields	High correlation
`TMIN-CAB` is highly correlated with `Demanda` and 7 other fields	High correlation
`TMIN-HMO` is highly correlated with `Demanda` and 7 other fields	High correlation
`TMIN-OBR` is highly correlated with `Demanda` and 7 other fields	High correlation
`Month` is highly correlated with `Demanda` and 7 other fields	High correlation
`Season` is highly correlated with `Demanda` and 7 other fields	High correlation
`Date_time` has unique values	Unique
`Date` has 19847 (14.3%) zeros	Zeros
`Hour` has 5782 (4.2%) zeros	Zeros
`PREC_HMO (mm)` has 120839 (87.1%) zeros	Zeros
`PREC_OBR (mm)` has 122255 (88.1%) zeros	Zeros

Reproduction

Analysis started	2022-11-08 15:58:32.925716
Analysis finished	2022-11-08 15:59:11.024482
Duration	38.1 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

FECHA
Date

Distinct	5783
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2007-01-01 00:00:00
Maximum	2022-10-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Demanda
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	45638
Distinct (%)	32.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2505.570239

Minimum	959
Maximum	5402.72
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	959
5-th percentile	1408
Q1	1867
median	2343.74
Q3	3054.1
95-th percentile	4079
Maximum	5402.72
Range	4443.72
Interquartile range (IQR)	1187.1

Descriptive statistics

Standard deviation	823.7167817
Coefficient of variation (CV)	0.3287542168
Kurtosis	-0.2876228818
Mean	2505.570239
Median Absolute Deviation (MAD)	559.74
Skewness	0.6406278244
Sum	347750599
Variance	678509.3364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1600	82	0.1%
1786	80	0.1%
1515	78	0.1%
1497	76	0.1%
1574	72	0.1%
1784	72	0.1%
1537	72	0.1%
1578	72	0.1%
1812	71	0.1%
1590	71	0.1%
Other values (45628)	138045	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
959	1	< 0.1%
966	1	< 0.1%
980	1	< 0.1%
999	1	< 0.1%
1001	1	< 0.1%
1002	1	< 0.1%
1003	2	< 0.1%
1004	1	< 0.1%
1005	1	< 0.1%
1006	1	< 0.1%

Value	Count	Frequency (%)
5402.72	1	< 0.1%
5399	1	< 0.1%
5390	1	< 0.1%
5348.84	1	< 0.1%
5336.53	1	< 0.1%
5297.23	1	< 0.1%
5295.02	1	< 0.1%
5290.24	1	< 0.1%
5289.39	1	< 0.1%
5286	1	< 0.1%

Date_time
Date

UNIQUE

Distinct	138791
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2007-01-01 01:00:00
Maximum	2022-10-31 23:00:00

Histogram

Histogram with fixed size bins (bins=50)

Date
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.99950285

Minimum	0
Maximum	6
Zeros	19847
Zeros (%)	14.3%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.000214279
Coefficient of variation (CV)	0.6668486011
Kurtosis	-1.250177853
Mean	2.99950285
Median Absolute Deviation (MAD)	2
Skewness	0.0001865299127
Sum	416304
Variance	4.000857163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	19847	14.3%
1	19824	14.3%
2	19824	14.3%
3	19824	14.3%
4	19824	14.3%
5	19824	14.3%
6	19824	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19847	14.3%
1	19824	14.3%
2	19824	14.3%
3	19824	14.3%
4	19824	14.3%
5	19824	14.3%
6	19824	14.3%

Value	Count	Frequency (%)
6	19824	14.3%
5	19824	14.3%
4	19824	14.3%
3	19824	14.3%
2	19824	14.3%
1	19824	14.3%
0	19847	14.3%

Hour
Real number (ℝ_≥0)

ZEROS

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.50008286

Minimum	0
Maximum	23
Zeros	5782
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	6
median	12
Q3	17.5
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.922167599
Coefficient of variation (CV)	0.6019232804
Kurtosis	-1.204170464
Mean	11.50008286
Median Absolute Deviation (MAD)	6
Skewness	-2.872424259 × 10^-6
Sum	1596108
Variance	47.91640427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	5783	4.2%
2	5783	4.2%
23	5783	4.2%
22	5783	4.2%
21	5783	4.2%
20	5783	4.2%
19	5783	4.2%
18	5783	4.2%
17	5783	4.2%
16	5783	4.2%
Other values (14)	80961	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5782	4.2%
1	5783	4.2%
2	5783	4.2%
3	5783	4.2%
4	5783	4.2%
5	5783	4.2%
6	5783	4.2%
7	5783	4.2%
8	5783	4.2%
9	5783	4.2%

Value	Count	Frequency (%)
23	5783	4.2%
22	5783	4.2%
21	5783	4.2%
20	5783	4.2%
19	5783	4.2%
18	5783	4.2%
17	5783	4.2%
16	5783	4.2%
15	5783	4.2%
14	5783	4.2%

Month
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.470383526

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.428032772
Coefficient of variation (CV)	0.5298036443
Kurtosis	-1.196339534
Mean	6.470383526
Median Absolute Deviation (MAD)	3
Skewness	0.003035689015
Sum	898031
Variance	11.75140869
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	11904	8.6%
5	11904	8.6%
7	11904	8.6%
8	11904	8.6%
10	11904	8.6%
1	11903	8.6%
4	11520	8.3%
6	11520	8.3%
9	11520	8.3%
12	11160	8.0%
Other values (2)	21648	15.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11903	8.6%
2	10848	7.8%
3	11904	8.6%
4	11520	8.3%
5	11904	8.6%
6	11520	8.3%
7	11904	8.6%
8	11904	8.6%
9	11520	8.3%
10	11904	8.6%

Value	Count	Frequency (%)
12	11160	8.0%
11	10800	7.8%
10	11904	8.6%
9	11520	8.3%
8	11904	8.6%
7	11904	8.6%
6	11520	8.3%
5	11904	8.6%
4	11520	8.3%
3	11904	8.6%

Season
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Spring	35328
Summer	35328
Autumn	34224
Winter	33911

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	832746
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Winter
2nd row	Winter
3rd row	Winter
4th row	Winter
5th row	Winter

Common Values

Value	Count	Frequency (%)
Spring	35328	25.5%
Summer	35328	25.5%
Autumn	34224	24.7%
Winter	33911	24.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
spring	35328	25.5%
summer	35328	25.5%
autumn	34224	24.7%
winter	33911	24.4%

Most occurring characters

Value	Count	Frequency (%)
m	104880	12.6%
r	104567	12.6%
u	103776	12.5%
n	103463	12.4%
S	70656	8.5%
i	69239	8.3%
e	69239	8.3%
t	68135	8.2%
p	35328	4.2%
g	35328	4.2%
Other values (2)	68135	8.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	693955	83.3%
Uppercase Letter	138791	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	104880	15.1%
r	104567	15.1%
u	103776	15.0%
n	103463	14.9%
i	69239	10.0%
e	69239	10.0%
t	68135	9.8%
p	35328	5.1%
g	35328	5.1%

Uppercase Letter

Value	Count	Frequency (%)
S	70656	50.9%
A	34224	24.7%
W	33911	24.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	832746	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	104880	12.6%
r	104567	12.6%
u	103776	12.5%
n	103463	12.4%
S	70656	8.5%
i	69239	8.3%
e	69239	8.3%
t	68135	8.2%
p	35328	4.2%
g	35328	4.2%
Other values (2)	68135	8.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	832746	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
m	104880	12.6%
r	104567	12.6%
u	103776	12.5%
n	103463	12.4%
S	70656	8.5%
i	69239	8.3%
e	69239	8.3%
t	68135	8.2%
p	35328	4.2%
g	35328	4.2%
Other values (2)	68135	8.2%

TMAX-CAB
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2134
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.99878551

Minimum	9.09
Maximum	49.61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	9.09
5-th percentile	19.8
Q1	26.96
median	33.73
Q3	39.5
95-th percentile	44.06
Maximum	49.61
Range	40.52
Interquartile range (IQR)	12.54

Descriptive statistics

Standard deviation	7.801089285
Coefficient of variation (CV)	0.2364053454
Kurtosis	-0.8615582407
Mean	32.99878551
Median Absolute Deviation (MAD)	6.27
Skewness	-0.2962016899
Sum	4579934.44
Variance	60.85699404
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	1392	1.0%
38	1248	0.9%
41	1200	0.9%
26	1128	0.8%
39	1128	0.8%
36	1104	0.8%
23	1080	0.8%
31	1056	0.8%
25	1056	0.8%
37	1008	0.7%
Other values (2124)	127391	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.09	24	< 0.1%
11	24	< 0.1%
12	72	0.1%
12.09	24	< 0.1%
12.23	24	< 0.1%
12.3	24	< 0.1%
12.5	24	< 0.1%
12.81	24	< 0.1%
13	72	0.1%
13.1	24	< 0.1%

Value	Count	Frequency (%)
49.61	24	< 0.1%
49.53	24	< 0.1%
48.4	24	< 0.1%
48.1	24	< 0.1%
48	24	< 0.1%
47.87	24	< 0.1%
47.71	24	< 0.1%
47.69	24	< 0.1%
47.6	24	< 0.1%
47.53	24	< 0.1%

TMAX-HMO
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1328
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.55376026

Minimum	8
Maximum	49.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	8
5-th percentile	21.77
Q1	28.71
median	34.5
Q3	39
95-th percentile	43
Maximum	49.1
Range	41.1
Interquartile range (IQR)	10.29

Descriptive statistics

Standard deviation	6.634450905
Coefficient of variation (CV)	0.1977260031
Kurtosis	-0.6405264241
Mean	33.55376026
Median Absolute Deviation (MAD)	5
Skewness	-0.3834708529
Sum	4656959.94
Variance	44.01593881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	3888	2.8%
39	3408	2.5%
38	3336	2.4%
35	3336	2.4%
40	3192	2.3%
41	3144	2.3%
36	2760	2.0%
42	2760	2.0%
34	2664	1.9%
30	2568	1.9%
Other values (1318)	107735	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	24	< 0.1%
14.58	24	< 0.1%
14.8	24	< 0.1%
15.5	48	< 0.1%
15.7	24	< 0.1%
15.71	24	< 0.1%
16	96	0.1%
16.01	24	< 0.1%
16.4	48	< 0.1%
16.5	144	0.1%

Value	Count	Frequency (%)
49.1	24	< 0.1%
48.86	24	< 0.1%
48	24	< 0.1%
47.58	24	< 0.1%
47.5	72	0.1%
47	96	0.1%
46.86	24	< 0.1%
46.5	120	0.1%
46.23	24	< 0.1%
46.2	24	< 0.1%

TMAX-OBR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1243
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.53774279

Minimum	12
Maximum	47
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	12
5-th percentile	24
Q1	30
median	35.41
Q3	39.28
95-th percentile	43
Maximum	47
Range	35
Interquartile range (IQR)	9.28

Descriptive statistics

Standard deviation	5.927637647
Coefficient of variation (CV)	0.1716278242
Kurtosis	-0.649182679
Mean	34.53774279
Median Absolute Deviation (MAD)	4.59
Skewness	-0.4153157434
Sum	4793527.86
Variance	35.13688808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	5856	4.2%
38	5568	4.0%
39	5424	3.9%
41	4992	3.6%
37	4704	3.4%
36	4320	3.1%
42	3792	2.7%
29	3744	2.7%
34	3648	2.6%
33	3600	2.6%
Other values (1233)	93143	67.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	24	< 0.1%
15	24	< 0.1%
16	48	< 0.1%
17	96	0.1%
17.7	24	< 0.1%
18	96	0.1%
18.5	24	< 0.1%
18.83	24	< 0.1%
19	168	0.1%
19.2	24	< 0.1%

Value	Count	Frequency (%)
47	48	< 0.1%
46.5	24	< 0.1%
46.15	24	< 0.1%
46	168	0.1%
45.97	24	< 0.1%
45.85	24	< 0.1%
45.7	24	< 0.1%
45.68	24	< 0.1%
45.5	48	< 0.1%
45.45	24	< 0.1%

TMIN-CAB
Real number (ℝ)

HIGH CORRELATION

Distinct	2169
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.49558574

Minimum	-6.8
Maximum	32.9
Zeros	192
Zeros (%)	0.1%
Negative	720
Negative (%)	0.5%
Memory size	1.1 MiB

Quantile statistics

Minimum	-6.8
5-th percentile	4
Q1	10.1
median	16
Q3	23.57
95-th percentile	28.78
Maximum	32.9
Range	39.7
Interquartile range (IQR)	13.47

Descriptive statistics

Standard deviation	7.921575778
Coefficient of variation (CV)	0.4802239766
Kurtosis	-1.016973919
Mean	16.49558574
Median Absolute Deviation (MAD)	6.64
Skewness	-0.0117286117
Sum	2289438.84
Variance	62.75136281
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	1440	1.0%
12	1440	1.0%
24	1368	1.0%
10	1248	0.9%
8	1224	0.9%
14	1200	0.9%
9	1176	0.8%
15	1151	0.8%
23	1104	0.8%
26	1080	0.8%
Other values (2159)	126360	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.8	24	< 0.1%
-5.8	24	< 0.1%
-5.4	24	< 0.1%
-5	24	< 0.1%
-3.2	24	< 0.1%
-3	48	< 0.1%
-2.92	24	< 0.1%
-2.2	24	< 0.1%
-2.13	24	< 0.1%
-2	48	< 0.1%

Value	Count	Frequency (%)
32.9	24	< 0.1%
32.86	24	< 0.1%
32.5	24	< 0.1%
32.48	24	< 0.1%
32.36	24	< 0.1%
32.21	24	< 0.1%
32.06	24	< 0.1%
32.02	24	< 0.1%
32.01	24	< 0.1%
31.78	24	< 0.1%

TMIN-HMO
Real number (ℝ)

HIGH CORRELATION

Distinct	1338
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.50379463

Minimum	-3
Maximum	34
Zeros	24
Zeros (%)	< 0.1%
Negative	24
Negative (%)	< 0.1%
Memory size	1.1 MiB

Quantile statistics

Minimum	-3
5-th percentile	7.09
Q1	13
median	18
Q3	25
95-th percentile	29
Maximum	34
Range	37
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.05737714
Coefficient of variation (CV)	0.3814016143
Kurtosis	-1.049131135
Mean	18.50379463
Median Absolute Deviation (MAD)	6
Skewness	-0.1101890143
Sum	2568160.16
Variance	49.8065721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	4344	3.1%
26	3624	2.6%
25	3600	2.6%
11	3240	2.3%
16	3239	2.3%
28	3120	2.2%
13	3000	2.2%
14	2952	2.1%
22	2880	2.1%
12	2784	2.0%
Other values (1328)	106008	76.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3	24	< 0.1%
0	24	< 0.1%
0.37	24	< 0.1%
0.46	24	< 0.1%
0.62	24	< 0.1%
0.66	24	< 0.1%
0.68	24	< 0.1%
0.7	24	< 0.1%
1.06	24	< 0.1%
1.23	24	< 0.1%

Value	Count	Frequency (%)
34	24	< 0.1%
33.4	24	< 0.1%
33.3	24	< 0.1%
32	168	0.1%
31.8	24	< 0.1%
31.73	24	< 0.1%
31.5	48	< 0.1%
31.39	24	< 0.1%
31.07	24	< 0.1%
31	720	0.5%

TMIN-OBR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1304
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.66678272

Minimum	2
Maximum	42.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	2
5-th percentile	8.22
Q1	13
median	18
Q3	25
95-th percentile	29
Maximum	42.5
Range	40.5
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.737229591
Coefficient of variation (CV)	0.36092077
Kurtosis	-1.139080852
Mean	18.66678272
Median Absolute Deviation (MAD)	6
Skewness	0.02303209835
Sum	2590781.44
Variance	45.39026256
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	5328	3.8%
25	4776	3.4%
14	4559	3.3%
27	4464	3.2%
24	4440	3.2%
10	4128	3.0%
13	3984	2.9%
16	3936	2.8%
15	3864	2.8%
11	3792	2.7%
Other values (1294)	95520	68.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	48	< 0.1%
2.6	24	< 0.1%
3	24	< 0.1%
3.3	24	< 0.1%
3.88	24	< 0.1%
4	48	< 0.1%
4.04	24	< 0.1%
4.1	24	< 0.1%
4.34	24	< 0.1%
4.48	24	< 0.1%

Value	Count	Frequency (%)
42.5	24	< 0.1%
33	24	< 0.1%
32	144	0.1%
31.96	24	< 0.1%
31.92	24	< 0.1%
31.67	24	< 0.1%
31.62	24	< 0.1%
31.56	24	< 0.1%
31.51	24	< 0.1%
31.41	24	< 0.1%

PREC_HMO (mm)
Real number (ℝ_≥0)

ZEROS

Distinct	252
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.398324099

Minimum	0
Maximum	117
Zeros	120839
Zeros (%)	87.1%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7.2
Maximum	117
Range	117
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.939963432
Coefficient of variation (CV)	4.963057876
Kurtosis	76.87536046
Mean	1.398324099
Median Absolute Deviation (MAD)	0
Skewness	7.721436168
Sum	194074.8
Variance	48.16309244
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	120839	87.1%
0.01	3312	2.4%
1	480	0.3%
0.3	384	0.3%
1.2	360	0.3%
0.5	336	0.2%
0.1	312	0.2%
2	288	0.2%
0.2	288	0.2%
3	264	0.2%
Other values (242)	11928	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	120839	87.1%
0.01	3312	2.4%
0.04	24	< 0.1%
0.1	312	0.2%
0.2	288	0.2%
0.3	384	0.3%
0.4	192	0.1%
0.5	336	0.2%
0.6	96	0.1%
0.7	144	0.1%

Value	Count	Frequency (%)
117	24	< 0.1%
115	24	< 0.1%
103.9	24	< 0.1%
92.1	24	< 0.1%
83.5	24	< 0.1%
80.5	24	< 0.1%
80	24	< 0.1%
72.5	24	< 0.1%
72	24	< 0.1%
71.8	24	< 0.1%

PREC_OBR (mm)
Real number (ℝ_≥0)

ZEROS

Distinct	184
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.166726373

Minimum	0
Maximum	166.8
Zeros	122255
Zeros (%)	88.1%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4.5
Maximum	166.8
Range	166.8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.680982958
Coefficient of variation (CV)	5.726263771
Kurtosis	141.1251942
Mean	1.166726373
Median Absolute Deviation (MAD)	0
Skewness	10.03783287
Sum	161931.12
Variance	44.63553329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122255	88.1%
0.01	2856	2.1%
1	1440	1.0%
0.5	936	0.7%
2	720	0.5%
1.5	552	0.4%
3	480	0.3%
2.5	384	0.3%
5	336	0.2%
9	264	0.2%
Other values (174)	8568	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	122255	88.1%
0.01	2856	2.1%
0.05	24	< 0.1%
0.1	144	0.1%
0.2	216	0.2%
0.3	240	0.2%
0.4	24	< 0.1%
0.5	936	0.7%
0.6	96	0.1%
0.7	24	< 0.1%

Value	Count	Frequency (%)
166.8	24	< 0.1%
104	24	< 0.1%
102	24	< 0.1%
101	24	< 0.1%
91.7	24	< 0.1%
91	24	< 0.1%
85	24	< 0.1%
81	24	< 0.1%
80.6	24	< 0.1%
74	24	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	FECHA	Demanda	Date_time	Hour	Month	Season	TMAX-CAB	TMAX-HMO	TMAX-OBR	TMIN-CAB	TMIN-HMO	TMIN-OBR
0	2007-01-01	1297.0	2007-01-01 01:00:00	1	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
1	2007-01-01	1255.0	2007-01-01 02:00:00	2	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
2	2007-01-01	1222.0	2007-01-01 03:00:00	3	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
3	2007-01-01	1168.0	2007-01-01 04:00:00	4	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
4	2007-01-01	1128.0	2007-01-01 05:00:00	5	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
5	2007-01-01	1100.0	2007-01-01 06:00:00	6	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
6	2007-01-01	1083.0	2007-01-01 07:00:00	7	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
7	2007-01-01	1076.0	2007-01-01 08:00:00	8	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
8	2007-01-01	1022.0	2007-01-01 09:00:00	9	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5
9	2007-01-01	1029.0	2007-01-01 10:00:00	10	1	Winter	21.0	21.5	25.0	2.0	9.0	7.5

Last rows

	FECHA	Demanda	Date_time	Hour	Month	Season	TMAX-CAB	TMAX-HMO	TMAX-OBR	TMIN-CAB	TMIN-HMO	TMIN-OBR
138781	2022-10-31	2834.87	2022-10-31 14:00:00	14	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138782	2022-10-31	2914.07	2022-10-31 15:00:00	15	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138783	2022-10-31	2990.75	2022-10-31 16:00:00	16	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138784	2022-10-31	3038.08	2022-10-31 17:00:00	17	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138785	2022-10-31	3014.08	2022-10-31 18:00:00	18	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138786	2022-10-31	2934.74	2022-10-31 19:00:00	19	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138787	2022-10-31	2926.85	2022-10-31 20:00:00	20	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138788	2022-10-31	2894.38	2022-10-31 21:00:00	21	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138789	2022-10-31	2877.56	2022-10-31 22:00:00	22	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0
138790	2022-10-31	2843.08	2022-10-31 23:00:00	23	10	Autumn	29.0	31.5	31.5	15.0	16.0	14.0

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows